package zero.tech.games.gate.mapper;

import java.util.Date;

import org.apache.ibatis.annotations.Select;

import zero.tech.games.gate.data.ExtensionRewardInfo;

public interface ClubMemberWaterSummeryMapper {

	@Select("select ifnull(sum(water_zs),0) as total_water_zs,ifnull(sum(water_fzs),0) as total_water_fzs,"
			+ "ifnull(sum(water_zs_effect),0) as total_water_zs_effect,ifnull(sum(water_fzs_effect),0) as total_water_fzs_effect "
			+ "from club_member_water_summery where club_id=#{club_id} and uid=#{uid} and create_stamp between #{begin} and #{end}")
	ExtensionRewardInfo selectExtensionRewardInfo(int club_id, int uid, Date begin, Date end);
}
